Click here to Skip to main content
15,900,511 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
Questionsql: insert into ... mixed with english and unicode fields Pin
includeh108-Sep-09 8:01
includeh108-Sep-09 8:01 
assume the table has 2 fields: fe and fu.
fe (field-english) is english text field.
fu (field-unicode) is unicode text field.

also assume X is an unicode character, whose value is 1212 (hex word).

now we insert english string ab into field fe, Xa (values are 1212 6100) into fu.

how do we writesql statement?
i.e.

sql="insert into mytable (fe,fu) values(\'ab\', \'\x12\x12\x61\x00\' )";

the \x00 terminates the sql statement string.

any idea or suggestion?

(I am testing mysql database now, CString with unicode setting is not really suitable for mysql in the case).

thanks
NewsUnit testing framework cfix 1.5 released; adds support for EXE targets and kernel mode multithreading Pin
J. Passing8-Sep-09 7:26
J. Passing8-Sep-09 7:26 
GeneralPublish an RTMP stream to FMS using Microrosft Visual C Pin
mseureka8-Sep-09 6:47
mseureka8-Sep-09 6:47 
GeneralRe: Publish an RTMP stream to FMS using Microrosft Visual C Pin
farnhamj12-Sep-09 14:32
farnhamj12-Sep-09 14:32 
GeneralRe: Publish an RTMP stream to FMS using Microrosft Visual C Pin
Sumit_Ghosh16-Sep-09 8:34
Sumit_Ghosh16-Sep-09 8:34 
GeneralRe: Publish an RTMP stream to FMS using Microrosft Visual C Pin
Jon68z16-Oct-09 8:36
Jon68z16-Oct-09 8:36 
GeneralRe: Publish an RTMP stream to FMS using Microrosft Visual C Pin
Gavriloaie Andrei7-Nov-09 2:21
Gavriloaie Andrei7-Nov-09 2:21 
GeneralRe: Publish an RTMP stream to FMS using Microrosft Visual C Pin
Jon68z7-Nov-09 16:15
Jon68z7-Nov-09 16:15 
GeneralRe: Publish an RTMP stream to FMS using Microrosft Visual C Pin
Gavriloaie Andrei7-Nov-09 16:30
Gavriloaie Andrei7-Nov-09 16:30 
GeneralRe: Publish an RTMP stream to FMS using Microrosft Visual C Pin
Jon68z7-Nov-09 16:50
Jon68z7-Nov-09 16:50 
QuestionImplicit conversion from char * to string: g++ vs VS Pin
dplong8-Sep-09 6:40
dplong8-Sep-09 6:40 
AnswerRe: Implicit conversion from char * to string: g++ vs VS Pin
Stuart Dootson8-Sep-09 10:24
professionalStuart Dootson8-Sep-09 10:24 
QuestionVC++ MFC Strlen [modified] Pin
GC1048-Sep-09 4:09
GC1048-Sep-09 4:09 
QuestionRe: VC++ MFC Strlen Pin
David Crow8-Sep-09 4:39
David Crow8-Sep-09 4:39 
AnswerRe: VC++ MFC Strlen Pin
GC1048-Sep-09 4:52
GC1048-Sep-09 4:52 
AnswerRe: VC++ MFC Strlen Pin
Stuart Dootson8-Sep-09 4:51
professionalStuart Dootson8-Sep-09 4:51 
GeneralRe: VC++ MFC Strlen Pin
GC1048-Sep-09 4:59
GC1048-Sep-09 4:59 
GeneralRe: VC++ MFC Strlen Pin
Stuart Dootson8-Sep-09 5:17
professionalStuart Dootson8-Sep-09 5:17 
QuestionVC++ MFC class data member initialisation [modified] Pin
GC1048-Sep-09 1:59
GC1048-Sep-09 1:59 
AnswerRe: VC++ MFC class data member initialisation Pin
CPallini8-Sep-09 2:10
mveCPallini8-Sep-09 2:10 
AnswerRe: VC++ MFC class data member initialisation Pin
Code-o-mat8-Sep-09 3:50
Code-o-mat8-Sep-09 3:50 
GeneralRe: VC++ MFC class data member initialisation Pin
GC1048-Sep-09 4:00
GC1048-Sep-09 4:00 
Questionwhich module creates a specific file? Pin
Joseph Marzbani8-Sep-09 1:25
Joseph Marzbani8-Sep-09 1:25 
AnswerRe: which module creates a specific file? Pin
Garth J Lancaster8-Sep-09 1:52
professionalGarth J Lancaster8-Sep-09 1:52 
GeneralRe: which module creates a specific file? Pin
Joseph Marzbani8-Sep-09 3:00
Joseph Marzbani8-Sep-09 3:00 

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.