mysql×Ö·û¼¯ºÍУ¶ÔÒý·¢µÄÎÊÌâ...

Create DATABASE IF NOT EXISTS aaa default charset utf8 COLLATE utf8_general_ci;


ÓÃÕâ¸ö½¨ºÃµÄÊý¾Ý¿â,ʹÓÃÓï¾ä²éѯ,

    TQuery* qUserRole=new TQuery(this);
    qUserRole->Close();
    qUserRole->SQL->Clear();
    qUserRole->SQL->Add("select ROLEID from USER ");
    qUserRole->SQL->Add("where USERID=:USERID ");
    qUserRole->ParamByName("USERID")->AsString=userID;
    qUserRole->Prepare();
    qUserRole->Open();
    sRole=qUserRole->FieldByName("ROLEID")->AsString;


²é³öÀ´µÄ½á¹û±¨´í,È¡µ½µÄÖµÊÇÂÒÂë...

È»ºóÓÖÖØн¨ÁËÒ»¸öÊý¾Ý¿â,
Create DATABASE IF NOT EXISTS bbb default charset latin1 COLLATE latin1_general_ci;

ÒÀ¾ÉÂÒÂë


×îºóÓÖ½¨ÁËÒ»¸öÊý¾Ý¿â,
Create DATABASE IF NOT EXISTS bbb default charset latin1;

Õâ´ÎÈ¡µ½µÄÖµÊÇNULL,


ÕâÊÇÔõô»ØÊÂ?  MySqlĬÈϵÄУ¶ÔÊÇÄÄÖÖ?

---

ßí latin1ĬÈϵÄУ¶ÔÔ­À´ÊÇlatin1_swedish_ci

Ë­À´½âÊÍϲ»Í¬×Ö·û¼¯»òÕßУ¶ÔΪʲô»á³öÏÖ²»Í¬µÄ²éѯ½á¹û?

---

˵ÂÒÂë¿ÉÄܲ»Ì«È·ÇÐ
ÎÒµÄʧÎó..

µ÷ÊÔµÄʱºò¹Û²âÈ¡³öÀ´µÄ±äÁ¿µÄÖµ,ÌáʾÈçÏÂ:
E2122 Fuction Call terminated by unhandled exception 0xeedfade at address 0x7c812a5b

ÎÒµÄÆ