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 |
|
micnie_2020
Posting Yak Master
232 Posts |
 Posted - 2009-04-23 : 22:38:58
|
| Hi,I need help on encode chinese character in utf-8 to ms sql as ?? to be #19978;#24093; in ms sql function. Now the ms sql become funny charcater after stored chinese character. The DB is standard for all language. can be store english also. Just i have an column called language. How can i do that?Pls advise. Thank you.Just an idea - Something like javascript :-<script language="JavaScript">var tstr = "<%=TEXT%>";var bstr = ''; for(i=0; i<tstr.length; i++) { if(tstr.charCodeAt(i)>127) { bstr += '#' + tstr.charCodeAt(i) + ';'; } else { bstr += tstr.charAt(i); } location.href="?a="+bstr }</script>Regards,Michelle |
|
|
|
|
|
Re: Chinese Encode Character