Friday, July 19, 2013

An idea for a side project

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.

No comments:

Creative Commons License
Oustside The Asylum by Ted Seeber is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States License.
Based on a work at