Click here to Skip to main content
15,925,371 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: SQL statement Pin
henli23-Jul-03 15:15
henli23-Jul-03 15:15 
GeneralRe: SQL statement Pin
Philip Patrick23-Jul-03 19:01
professionalPhilip Patrick23-Jul-03 19:01 
GeneralRe: SQL statement Pin
henli23-Jul-03 21:31
henli23-Jul-03 21:31 
General[Help] Host Windows User Control in IE – (Security?) Pin
Frank W. Wu22-Jul-03 8:38
Frank W. Wu22-Jul-03 8:38 
GeneralASP - need help: Storing foreign char to SQL DB. Pin
ckatili21-Jul-03 8:39
ckatili21-Jul-03 8:39 
GeneralRe: ASP - need help: Storing foreign char to SQL DB. Pin
Steve McLenithan21-Jul-03 18:09
Steve McLenithan21-Jul-03 18:09 
GeneralRe: ASP - need help: Storing foreign char to SQL DB. Pin
Heath Stewart21-Jul-03 18:16
protectorHeath Stewart21-Jul-03 18:16 
GeneralRe: ASP - need help: Storing foreign char to SQL DB. Pin
ckatili22-Jul-03 12:00
ckatili22-Jul-03 12:00 
Thanks Steve and Heath for your reply.

I found the solution, although it was not obvious at first.

It turns out that web application uses UTF-8 encoding, and SQL uses UCS-2.
This different encoding standard caused the wrong data conversion.

The following article explains the issue:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;232580

I hope this helps other people who has similar issue.


Charles

"Computers are like Old Testament gods; lots of rules and no mercy." -JosephCampbell

GeneralCorrect Me if I am Wrong But.... Pin
DxSolo21-Jul-03 5:39
DxSolo21-Jul-03 5:39 
GeneralRe: Correct Me if I am Wrong But.... Pin
Ian Darling21-Jul-03 5:43
Ian Darling21-Jul-03 5:43 
GeneralRe: Correct Me if I am Wrong But.... Pin
theJazzyBrain21-Jul-03 6:19
theJazzyBrain21-Jul-03 6:19 
GeneralRe: Correct Me if I am Wrong But.... Pin
Roger Wright21-Jul-03 8:52
professionalRoger Wright21-Jul-03 8:52 
GeneralRe: Correct Me if I am Wrong But.... Pin
Nino_121-Jul-03 17:45
Nino_121-Jul-03 17:45 
GeneralRe: Correct Me if I am Wrong But.... Pin
Not Active22-Jul-03 7:23
mentorNot Active22-Jul-03 7:23 
GeneralRe: Correct Me if I am Wrong But.... Pin
Not Active22-Jul-03 7:26
mentorNot Active22-Jul-03 7:26 
GeneralRe: Correct Me if I am Wrong But.... Pin
theJazzyBrain22-Jul-03 14:42
theJazzyBrain22-Jul-03 14:42 
GeneralRe: Correct Me if I am Wrong But.... Pin
Philip Patrick23-Jul-03 0:40
professionalPhilip Patrick23-Jul-03 0:40 
Generalsoap tookit 3.0 redistribution Pin
soratauc21-Jul-03 1:42
soratauc21-Jul-03 1:42 
GeneralRe: soap tookit 3.0 redistribution Pin
Heath Stewart21-Jul-03 18:22
protectorHeath Stewart21-Jul-03 18:22 
Generaljavascripts help Pin
henli20-Jul-03 19:48
henli20-Jul-03 19:48 
GeneralRe: javascripts help Pin
Ryan Binns20-Jul-03 22:57
Ryan Binns20-Jul-03 22:57 
GeneralRe: javascripts help Pin
Anonymous20-Jul-03 23:05
Anonymous20-Jul-03 23:05 
GeneralRe: javascripts help Pin
Ryan Binns20-Jul-03 23:09
Ryan Binns20-Jul-03 23:09 
GeneralRe: javascripts help Pin
henli20-Jul-03 23:27
henli20-Jul-03 23:27 
GeneralRe: javascripts help Pin
-- NA --23-Jul-03 0:54
-- NA --23-Jul-03 0:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.