Member Avatar for Pece__

Hi there! I have one problem and I'm asking for some help :).I want to change font from one column to Unicode... is there some easy way to do that? :S

  • 3 Contributors
  • 2 Replies
  • 84 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by luap599
Member Avatar for drjohn

Unicode is not a font, it is a character set.
Fonts are on-screen shapes applied to the characters present in the character set.
The character set controls the number and type of characters you can use. (the alphabet(s) it can use)

To change the character set of a given column, a quick visit to the manual gives this little bit of sql

ALTER TABLE t1 MODIFY
    col1 VARCHAR(5)
      CHARACTER SET latin1
      COLLATE latin1_swedish_ci;

so you just have to insert the appropriate table and column names (and data type), and set the character set and collation as required. the collation would be utf8_unicode_ci, probably.

Member Avatar for luap599

drjohn
You are right on the mark!

SQLyog programe I use, inserts; the COLLATE; then enters the CHARACTER SET
Paul

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.