May 10, 2017 at 3:36 pm
I'm importing a text file that has path/file names that have accents in them.
For example, below you can see the accents/special characters.
in windows explorer I see this:
1027948_16356344_wk 35 @NIVEA BODY@48965 Body 625ml 77240 CrŠme Soft 250-200ml 24253 Inshower @ AD @ $0 30 $0 50 $0 05 @ RCWC EF_VS.xlsm
After importing it to SQL server from a text file:
1027948_16356344_wk 35 @NIVEA BODY@48965 Body 625ml 77240 Crème Soft 250-200ml 24253 Inshower @ AD @ $0 30 $0 50 $0 05 @ RCWC EF_VS.xlsm
I import a text file with the path/filename and it changes the accent. I import it into a varchar type column. Should it be a different type? how is the best way to import the text file?
thanks,
Alex
May 10, 2017 at 4:18 pm
Actually, just realized it is not at this stage where it is changed. Data is fine.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply