How to store unicode in MySQL? -

-

how store unicode in free edition of mysql?

there doesn't seem nvarchar type in sql server. unicode not supported in mysql? tried using text not working.

you need choose utf8_* character set table. text , memo fields automatically stored in utf-8. support utf-16 coming in mysql 6.


Comments

Post a Comment

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

-
i'm working on installer (using wise installer, older version 1999). i'm creating shortcut in programs group exe. i'm creating shortcut on desktop. if install run admin account, create shortcut on common desktop , common program group (i.e., read hkey_local_machine\explorer\shellfor users). if it's installed nonadmin account, install hkey_current_user's desktop , program group. behavior install on: xp nonadmin - desktop , program shortcuts install ok. vista admin - desktop & program shortcuts install ok. vista non-admin, uac off - desktop shortcut installs, program shortcut not . however, program group folder they're supposed installed does created. at end of install, launch program group has shorcut. launches in of above. can manually drag shortcut folder , works fine. i'm bloody baffled. i've tried installing other commercial apps (opera, foxit, firefox) firefox install under nonadmin (and if select other program files,...
Read more

Customizing UserCreationForm for email address as username in Django 1.2 -

-
django 1.2 adds new allowable symbols usernames, meaning usernames can email addresses. until have been using inbuilt usercreationform registration - how can alter label 'username' field 'email' field? , how add (but still user object) fields such first , last names? (and how make them optional?) should altering usercreationform extent or better starting scratch (and if latter, how?) thanks. to change label of email field, can subclass usercreationform follows from django import forms django.utils.translation import ugettext_lazy _ django.contrib.auth.forms import usercreationform class myusercreationform(usercreationform): username = forms.regexfield(label=_("email"), max_length=30, regex=r'^[\w.@+-]+$', help_text = _("required. 30 characters or fewer. letters, digits , @/./+/-/_ only."), error_messages = {'invalid': _("this value may contain letters, numbers , @/./+/-/_ characters."...
Read more

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more