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.

Comments

Popular posts from this blog

Proposed Amendment 28

Father claims 15 year old girl is capable of consent in Lesbian Rape Case

Call them what you like, Broken Families are still a TRAGEDY!