current community

your communities

more stack exchange communities

Stack Exchange Inbox Reputation and Badges
tour help
Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I need to convert UNICODE column values from UTF16-LE to UTF-8 to then import into MySQL. Is it safe to assume columns of NVARCHAR, NTEXT, NCHAR, BIT, INT, DECIMAL, FLOAT, and DATETIME all MUST be UNICODE and therefore WILL NOT have any characters unable to be converted from UTF-16LE to UTF-8 simply by exporting the values to a .txt file and resaving them with the UTF-8 Encoding prior to importing them to MySQL?

share|improve this question
    
Bit, Int, Decimal, Float????? SERIOUSLY? You think they get stored as strings? Unicode only applies to strings, IIRC. –  TomTom Sep 25 '13 at 17:05
    
OK - Any other helpful comments? –  user2732180 Sep 25 '13 at 17:23
    
@TomTom: I believe MySQL does store them as strings, which I think is why the question is being asked. –  Jon Seigel Sep 25 '13 at 17:24
    
Seriously? dev.mysql.com/doc/refman/5.0/en/storage-requirements.html says no - as an int is using 4 bytes... –  TomTom Sep 25 '13 at 17:29
    
Hmmm... I guess I'm thinking of something else. Never mind. –  Jon Seigel Sep 25 '13 at 17:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.