Hello,
I would like save text (different languages) in a MySQL-Table and I
don't know, which Collation is the right one for me.
utf8_bin or utf8_general_ci?
OK, in utf8_general_ci I know that the Collation is CASE INTENSIVE but
it isn't a problem. But what is better for
Text in different
Thank you very much for all answers
I will trying Triggers and the example with the update after an INSERT.
Ant then, I use the best for me;-)
Thunder
Yes, Triggers... I so rarely use them I forget they exist.
On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt mli...@rp-online.de wrote:
Hello,
I have a questions and I hope, that is possible in MySQL.
I have the following short Table.
CREATE TABLE IF NOT EXISTS `testtable` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`id-crc` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id-crc` (`id-crc`)
)
to do it on
the select side of the equation?
SELECT id,CRC32(id) AS id-crc... FROM testtable...
-jw
On Sun, May 3, 2009 at 7:16 AM, thun...@isfahan.at thun...@isfahan.atwrote:
Hello,
I have a questions and I hope, that is possible in MySQL.
I have the following short Table.
CREATE TABLE
,CRC32(id) AS id-crc... FROM testtable...
-jw
On Sun, May 3, 2009 at 7:16 AM, thun...@isfahan.at thun...@isfahan.atwrote:
Hello,
I have a questions and I hope, that is possible in MySQL.
I have the following short Table.
CREATE TABLE IF NOT EXISTS `testtable` (
`id` bigint(20) unsigned NOT NULL
