Unix and Android systems (iOS and Android smart phones and tablets) use UTF-8 unicode encoding.
Microsoft products, such as SQL Server, use UTF-16.
This can cause a bug where the wrong characters are entered into the database. But they can be taken care of with the Replace function:
Set @AppVersion=REPLACE(@AppVersion,'®','®')
Next time I have some down time, I should write a program that creates a table and function, for alternate character sets, to replace properly.
I'm Outside the Autistic Asylum!
RSS Feed link
The crazy stuff I can't post anyplace else
Introduction to Wonko the Sane and Outside the Asylum, which this blog is named after.
No comments:
Post a Comment