forums › forums › SQLyog › Using SQLyog › Error Code 1210: wrong arguments to =
- This topic is empty.
-
AuthorPosts
-
-
July 3, 2003 at 12:20 pm #8081
bass
MemberHello,
I have folloqing table:
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
I tried to insert special characters like “õéáûúóü…” with SQLYOG and other
clients but after inserting
all they are substituted with a “?”. So I have entries like “Sz?veg ?s k?pek”.
If I want print the entries on a HTML-page I don't see the correct chars but
only “?”.
Beside this problem, for some special chars, on inserting, i get the error
“Error Code 1210: Wrong arguments to =”. The SQL-statement is:
update tblTrnHU set TrnDesc=”Szakácsmûvészet” where TrnKey=”Gastronomy”;
Also I tried:
update tblTrnHU set TrnDesc=CONVERT(_utf8″Szakácsmûvészet” using utf8)
where TrnKey=”Gastronomy”;
but it result the same error!
My problem is that I cannot set charset to latin2 beacuse there are entries
of other languages (german,italian,english..) on the same table and they have
other special chars…
Can anybody help me?
MySQL Version: 4.1 (alpha)
Regards,
Bass
-
July 3, 2003 at 1:29 pm #14631
Shadow
MemberHi, 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 #14632Member
yes, but latin1 don't support some hungarian characters, that's the problem!
-
July 4, 2003 at 6:40 am #14633Member
Are you sure? I get all my Hungarian characters right…
-
July 4, 2003 at 7:24 am #14634Member
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 #14635Member
I know how an ? looks like, but my db stores and retrieves them correctly…
-
July 4, 2003 at 8:45 am #14636Member
Oops, the forum really cannot handle long ü correctly. ?= long ü in my previous entry.
-
July 4, 2003 at 9:40 am #14637Member
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 #14638Member
for info:
..on my machine I see a “?” for every unknown character…
-
July 4, 2003 at 10:54 am #14639Member
sorry for multiposting, but can you show/send me the configuration of your mysql server variables?
-
July 7, 2003 at 8:08 am #14640Member
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 #14641Member
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 #14642Member
What charset does your os use? Because that influences how SQLyog displays the characters!
-
July 8, 2003 at 3:00 pm #14643Member
thanks!
-
-
AuthorPosts
- You must be logged in to reply to this topic.
