Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Error Code 1210: wrong arguments to =

forums › forums › SQLyog › Using SQLyog › Error Code 1210: wrong arguments to =

  • This topic is empty.
Viewing 12 reply threads
  • Author
    Posts
    • July 3, 2003 at 1:29 pm #14631
      Shadow
      Member

      Hi, my fellow countryman!

      use latin1 insted of utf8 as charset and you'll get “Szöveg és képek” immediatelly!

      So, insted of:

      Quote:
      CREATE TABLE `tblTrnHU` (

      `TrnKey` varchar(255) character set latin1 NOT NULL default '',

      `TrnRTS` bigint(20) default '0',

      `TrnDesc` varchar(255) default NULL,

      PRIMARY KEY (`TrnKey`)

      ) TYPE=MyISAM CHARSET=utf8

      use:

      CREATE TABLE `tblTrnHU` (

      `TrnKey` varchar(255) character set latin1 NOT NULL default '',

      `TrnRTS` bigint(20) default '0',

      `TrnDesc` varchar(255) default NULL,

      PRIMARY KEY (`TrnKey`)

      ) TYPE=MyISAM CHARSET=latin1

      It works for me and use 4.1-alpha as well

    • July 3, 2003 at 3:17 pm #14632
      bass
      Member

      yes, but latin1 don't support some hungarian characters, that's the problem!

    • July 4, 2003 at 6:40 am #14633
      Shadow
      Member

      Are you sure? I get all my Hungarian characters right…

    • July 4, 2003 at 7:24 am #14634
      bass
      Member

      yes I'm sure, I cannot post it here beacuse the forum doesn't

      support these character! it's a “ü”, not with two dots but with

      two little lines…

    • July 4, 2003 at 8:43 am #14635
      Shadow
      Member

      I know how an ? looks like, but my db stores and retrieves them correctly…

    • July 4, 2003 at 8:45 am #14636
      Shadow
      Member

      Oops, the forum really cannot handle long ü correctly. ?= long ü in my previous entry.

    • July 4, 2003 at 9:40 am #14637
      bass
      Member

      I don't now why, but on my machine it doesn't work with this long ü!

      With version of MySQL do you use? on witch OS?

    • July 4, 2003 at 9:41 am #14638
      bass
      Member

      for info:

      ..on my machine I see a “?” for every unknown character…

    • July 4, 2003 at 10:54 am #14639
      bass
      Member

      sorry for multiposting, but can you show/send me the configuration of your mysql server variables?

    • July 7, 2003 at 8:08 am #14640
      Shadow
      Member

      MySql 4.1-alpha on Win2K Prof. SP3 Hungarian version. What is the language of your OS? It may affect what you see because it will render characters differently! And I repeat: latin1 gets all my special characters right.

    • July 8, 2003 at 9:36 am #14641
      bass
      Member

      it's all ok, I solved the problem!

      Now I can save all special chars into the DB, but I noticed that sqlyog not shows me

      all characters correctly! for example I see a “û” instead a long ü, but in the table

      it's saved correctly as a long ü! PHP gets it correctly!

      does sqlyog have settings about charset for displaying these kind of chars ?

    • July 8, 2003 at 10:54 am #14642
      Shadow
      Member

      What charset does your os use? Because that influences how SQLyog displays the characters!

    • July 8, 2003 at 3:00 pm #14643
      bass
      Member

      thanks!

  • Author
    Posts
Viewing 12 reply threads
  • You must be logged in to reply to this topic.