Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harpreetkaur
Starting Member
14 Posts |
 Posted - 2007-02-17 : 20:44:09
|
| I wondered if MSDE and PHP allowed for Unicode character sets (such as by using the UTF-8 standard)? Would this also require changes to the MSDE tables/fields or global settings?We are planning on selling our product to the international market. Our product currently uses MSDE and PHP. The GUIs of our applications would not change but they would like for whatever the users type to be in their native language using the appropriate Unicode character set. Do we have a rough estimate of how much time it might take to make all of these changes in PHP and MSDE? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2007-02-18 : 12:57:33
|
| The SQL Server database engine doesn't know anything about the UTF-8 encoding of Unicode.If you want to store all characters from the Unicode Basic Multilingual Plane (U+0000 - U+FFFD) then you'll have to use nvarchar (etc.) type columns. If you want to store characters outside the BMP (U+10000 - U+10FFFD), you can try encoding it as UTF-16 in nvarchar, but don't expect much support from the database -- it'll treat the low and high surrogates as if they were characters (even in SQL Server 2005).Absolutely no idea about PHP. |
 |
|
|
|
|
|
Unicode UTF-8 Support