Datatype for alphanumeric value

sasi kumar8y ago

Hi,

Please try to convert the data to text type in excel sheet and save it and then upload it.

Thanks

0

Jayesh Vaghasiya8y ago

use Nvarchar(Max) data type

your data in special characters at that time prob.so use nVarchar(max)

0

Abe Garba13y ago

I mean you just 'CHANGE'

0

Abe Garba13y ago

You can just the field format by highlighting the data contains in the field then change the format to text (in Excel) Save the file then try to upload the file again, it will work!

0

Pravin More15y ago

Hi kavya,
I saw values you posted.It happens because of formating problems like .(dot) cooma or other escape character cuming .i had gone through same problem once.
so i had adjusted values by formating using single quote ,double quotes according to need.
so you have to do formating,you not mention which column is going
null....i think its Description One......Right?
if i was able to get your excel as it is ,it was easy for me to fetch
problem....still u can try formating values which are going null......
or try to reply with rar file.......i copy pasted it in excel but not getting in proper format...........
Thanx,i hope you will come to solve it
Pravin.

0

Ashwini15y ago

Hi pravin, can you able to see now, image is not possible to paste in editor area so i copied in table
sorry if anything wrong is there. In this product id contailns alphanumeric values and also in some places decimal values
alphanumeric and decimal values are not copied properly in database table. please refer it and tell me which datatype is
suited for this. Really thanks for your replay.

Product ID	FY12 List	TS	DS	PGC	Description One
35562014	311	SVC	G5	896	CONNECTOR
205091003	436000	SVC	G5	896	12.0 KVA TRANSFORMER
205091004	419000	SVC	G5	896	18.0 KVA TRANSFORMER
333	123000	SVC	G6	715	LUBELINK KIT FOR BOTTLE SAMPLING
334	592000	SVC	G6	715	DIGITAL CONTAMALERT LUBELINK BENCH KIT
415053005	5260	MOT	G8	731	SHAFT SEAL KIT, H8000 SERIES MOTOR
415056	2630	MOT	G8	731	SHAFT SEAL KIT, H2000 SERIES MOTOR
415058	4090	MOT	G8	731	SHAFT SEAL KIT, H4000 SERIES MOTOR
415059	4670	MOT	G8	731	SHAFT SEAL KIT, H6000 SERIES MOTOR
415060	3750	MOT	G8	731	SHAFT SEAL KIT, F4000 SERIES MOTOR
1150CNEXONIGHT	12900	SVC	G5	902	CON SAF EXP OVERNIGHT CHARGE
1150CNMATRA	66.2	SVC	G5	902	CON SAF MATERIAL (RA)
1150CNMATVEND	66.2	SVC	G5	902	CON SAF MATERIAL (3RD PARTY)
1150CNOTLBR13	17300	SVC	G5	713	CON SAF OT LABOR (1.3) A
1150CNOTLBR15	19900	SVC	G5	713	CON SAF OT LABOR (1.5) A
1150CNOTLBR175	23300	SVC	G5	713	CON SAF OT LABOR (1.75) A
1150CNOTLBR20	26600	SVC	G5	713	CON SAF OT LABOR (2.0) A
1150CNSCDBLBR	66.2	SVC	G5	902	SCON SAF (SUB CONT) DT 2.0 LABOR
1150CNSCOTLBR	66.2	SVC	G5	902	CON SAF (SUB CONT) OT 1.5 LABOR
1150CNSCSTLBR	66.2	SVC	G5	902	CON SAF (SUB CONT) STD LABOR
1150CNSTDLBR	13300	SVC	G5	713	CON SAF STANDARD LABOR
122.04.02	15600	SVC	G6	715	THYRISTOR, 310A, 1600V
122.06.11	7150	SVC	G6	715	THYRISTOR, 140 A, 1600V
122.78.01	137000	SVC	G6	715	THYRISTOR
122.93.02	31000	SVC	G6	715	THYRISTOR, 800A, 1600V
123.39.51	734	SVC	G6	715	SUPPRESSOR 625 VAC, 880 V/ 1MA
1238102	7050	SVC	G6	715	PROBE BODY CLR ANDZD/DCA PRESS
124.07.00	2110	SVC	G6	715	RECTIFIER,25A SWISS DRIVE
1252102	5440	SVC	G6	715	NEEDLE, ZINC PLATED/DCA PROBE
TLA110PHJ32AA	28700	MOT	G8	728	MOTOR, 0.18NM,2000 LINE
TLA120PHJ34AA	38200	MOT	G8	728	MOTOR,0.16NM,2000 LINE
TLA130PHK32AN	30800	MOT	G8	728	MOTOR,0.33NM,2000 LINE
TLA220PHJ32AA	35000	MOT	G8	728	MOTOR,0.84NM,2000 L
TLA220PHJ32AN	35000	MOT	G8	728	MOTOR,0.84NM,2000 L
TLA220PHJ34AA	44600	MOT	G8	728	MOTOR,0.76NM,2000 L
H8500SH04AA	540000	MOT	29	727	MOTOR/ENCODER/BRAKE
MPFA320HMJ24AA	174000	MOT	G8	723	MOTOR,SERVO,FDGRADE
MPFB330PSJ22AA	119000	MOT	G8	723	MOTOR,SERVO,FDGRADE,4.18
MPGB050091M22	532000	MOT	G8	732	MOTOR,SERVO,GEAR RA
MPGB050091M24	516000	MOT	G8	732	MOTOR,SERVO,GEAR RA
MPLA210VEJ42AA	55600	MOT	G8	721	MOTOR,SERVO,0.55 NM
MPLA210VVJ42AA	69000	MOT	G8	721	MOTOR,SERVO,0.55 NM
MPLA220TEJ42AA	60300	MOT	G8	721	MOTOR,SERVO,1.6 NM
MPLA220THJ42AA	55100	MOT	G8	721	MOTOR,SERVO,1.6 NM,6000
MPLA220THJ44AA	80300	MOT	G8	721	MOTOR,SERVO,1.6 NM,6000
MPLA220TVJ42AA	74100	MOT	G8	721	MOTOR,SERVO,1.6 NM,6000
MPLA220TVJ44AA	99100	MOT	G8	721	MOTOR,SERVO,1.6 NM,6000
MPLA230PHJ42AA	58000	MOT	G8	721	MOTOR,SERVO,2.1 NM, MPL
MPLA230PHJ44AA	82800	MOT	G8	721	MOTOR,SERVO,2.1 NM,5000
RM2250102901	166000	MOT	J7	444	IGBT MODULE
RM7410388207	3160	MOT	J7	444	CABLE HRNS ASSY,6AWG,
RP1775MEA	2440000	MOT	G6	715	PLC-3 ERROR CORRECTING
S200TB3/A	2330	PLC	K2	898	3 WIRE TERMINAL BASE
SP151134	112000	MOT	G6	715	KIT PCB BASE DRIVER/PWR
SP151137	113000	MOT	G6	715	KIT PCB BASE DRIVER/PWR
SP151138	113000	MOT	G6	715	KIT PCB BASE DRIVER/PWR
SP151140	168000	MOT	G6	715	KIT PCB BASE DRIVER/PWR
SP151141	176000	MOT	G6	715	KIT PCB BASE DRIVER/PWR
SP151143	176000	MOT	G6	715	KIT PCB BASE DRIVER/PWR
TLA110PHJ32AA	28700	MOT	G8	728	MOTOR, 0.18NM,2000 LINE
TLA120PHJ34AA	38200	MOT	G8	728	MOTOR,0.16NM,2000 LINE
CEP7A32520	3340	NPL	B3	125	CEP7-A32-5-10
CEP7A454510	7030	NPL	B3	125	ELECTRONIC OVERLOAD
CEP7A858510	7890	NPL	B3	125	CEP7-A SOLID STATE
CEP7A858520	7890	NPL	B3	125	ELEC OVERLOAD
CEP7B3212	6060	NPL	B3	125	ELECTRONIC OVERLOAD
CEP7B3229	6060	NPL	B3	125	SOLID STATE OVERLOAD
CEP7B3232	6240	NPL	B3	125	ELECTRONIC OVERLOAD
CEP7B3745	9230	NPL	B3	125	ELECTRONIC OVERLOAD
CEP7B4545	9230	NPL	B3	125	CEP7-B45-45
CEP7SM32710	3100	NPL	B3	125	CEP7S-M32-7-10
DS150A35NBNA	141000	SVC	G6	715	MOTOR 480V MAX
DS4133386BU	82200	MOT	G6	715	REGULATOR BOARD
DS60043436R	41100	MOT	G6	715	RELAY
EK46252I	11600	PLC	K4	579	ACCEL 9100EX GEN PURPOSE
H3007NH00AA	97000	MOT	29	727	BRUSHLESS MOTOR/ENC
H3016NH00AA	115000	MOT	29	727	SERVO MOTOR
H3016NH04AA	178000	MOT	29	727	SERVO MOTOR
H4030MH00AA	131000	MOT	29	727	BRUSHLESS MOTOR/ENCODER
H4030PH00AA	131000	MOT	29	727	BRUSHLESS MOTOR/ENCODER
H4030PH04AA	193000	MOT	29	727	MOTOR ENCODER BRAKE
H4050PH00AA	145000	MOT	29	727	8 HP ELECTRO CARPT MOTOR
H6100QH00AA	190000	MOT	29	727	BRUSHLESS MOTOR/ENCODER
H6100QH04AA	258000	MOT	29	727	BRUSHLESS MOTOR/ENCODER
H6300QH00AA	326000	MOT	29	727
H6300QH04AA	395000	MOT	29	727	MOTOR/ENCODER/BRAKE
H8500SH04AA	540000	MOT	29	727	MOTOR/ENCODER/BRAKE
MPFA320HMJ24AA	174000	MOT	G8	723	MOTOR,SERVO,FDGRADE
MPFB330PSJ22AA	119000	MOT	G8	723	MOTOR,SERVO,FDGRADE,4.18
MPGB050091M22	532000	MOT	G8	732	MOTOR,SERVO,GEAR RA
MPGB050091M24	516000	MOT	G8	732	MOTOR,SERVO,GEAR RA

0

Pravin More15y ago

sorry.....still not able to download.......its sites problem

better is dont add attachment just paste image here in editor through paint or somthing.

0

Ashwini15y ago

Hi pravin, i have sent as image through attached file, please download.

0

Pravin More15y ago

Sorry kavya....but i am noy able to download it....it giving error on page....it may be sites problem.......better is dont add attachment just paste image here through paint or somthing......i just want to see it.....i will get idea for problem.....

Thanx

0

Ashwini15y ago

Sorry pravin i have attached excel sheet directly thats why its not showing now i have sent mydata.zip file, find the attachment.

0

Pravin More15y ago

Kavya i cant see attached file...i think u forgot to attach.

0

Ashwini15y ago

Hi pravin,
i have sent my excel sheet through attached file please download it for reference. in this sheet product id column values are showing as NULL after copied to the database table. please help me regarding this.

0

Pravin More15y ago

Hi Kavya,
datatype is correct.............can you show image of excel file. i want to see column that is showing null value.

Thanx
Pravin.

0

Ashwini15y ago

Hi prabhu,
i have set datatype to varchar(max) only but still it has some problem, please help me regarding this.

0

Prabhu Raja15y ago

Hello Kavya, you can store 782ACg68.39 in varchar(max) column in sql server table. i think its problem with your functions.

0

Ashwini15y ago

Hi prabhu,

What i am doing is, in excel sheet i am having around 50000 rows of data, iam coping this excel sheet data to sql data base table by using the import and export functions in sql server, i have copied but in one column of excel sheet alphanumeric characters with decimal places is there for example 782ACg68.39. this data is not copied properly it showing NULL values for that particular row. i am not getting how to fix this problem. please help me regarding this.

0

Ashwini15y ago

Hi pravin,
What i am doing is, in excel sheet i am having around 50000 rows of data, iam coping this excel sheet data to sql data base table by using the import and export functions in sql server, i have copied but in one column of excel sheet alphanumeric characters with decimal places is there for example 782ACg68.39. this data is not copied properly it showing NULL values for that particular row. i am not getting how to fix this problem. please help me regarding this.

0

Pravin More15y ago

Hi Kavya,
can you please show your exact problem?

0

Hemant Kumar15y ago

Hi Please refer this link for more information
http://developer.mimer.com/documentation/html_92/Mimer_SQL_Mobile_DocSet/Syntax_Rules4.html

0

Priya Linge15y ago

Hi,

Please try this,

varchar: the varchar data type holds alphanumeric data; just like char but with flexible size, you just set the maximum number of characters, maximum size is 8,000 character.

nvachar: it's defined in samilier way to varcar but it uses unicode.Hope this will help you.

E.g :

create table chkdata
(alphavalues nvarchar(100),Id int identity(1,1))

insert into chkdata values('tyty5756765')

select * from chkdata

O/P : alphavalues       Id
           B06H8J9            1
          tyty5756765        2

Hope this will help you.

Thanks.

0

Prabhu Raja15y ago

Hello Kavya, varchar is datatype for storing alphanumeric values. I think, you can't get output because of some other reasons. can you show you table structure.

0