MySQL Forums
Forum List  »  General

Problem with Enums!!!???
Posted by: Kostyantyn Shakhov
Date: April 20, 2005 09:03AM

I have the mass_media table. I heve two data field of enum data type in it. These fields should be used for storing mass media types like Newspaper, Magazine, News agency etc. One of them should be used to store English names and the other to store an appropriate names in Ukrainian. The SQL statement looks like:
CREATE TABLE mass_media
(
type_eng ENUM("<eng_name>", "<eng_name>") NOT NULL,
type_ukr ENUM("<ukr_name>", "<ukr_name>") NOT NULL
);
The problem is when I trying to INSERT the data into this table all of English are inserted successfully into type_eng, but some of Ukrainian do not store (inserted a zero string). It looks like I tryed to insert a wrong data into type_ukr. That's not true. I tryed to insert completely the same data as defined in the above SQL.
The charset for that table is Latin1 (got from myisamchk.exe -dvv mass_media).
What's wrong. Can anybody help me? Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Problem with Enums!!!???
April 20, 2005 09:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.