Re: MySQL v. PostgreSQL

A number of things to be aware of.

MySQL supports setting the character set and collation at the column  
level. If it is not set it inherits the defauls, latin1 swedish case  
insensitive collation. Or the default for the DB or the server if set.

So the columns need to be set to UTF, explicitly or the default for  
the refdb DB needs to be set.

That controls how the data is stored..

There is more to the story..

Character set and collation for the connection.

You need to set those appropriately for the client.

Set names UTF8 perhaps. Or in a config file.
See this page..http://dev.mysql.com/doc/refman/5.1/en/charset- 
literal.html

I also see the bug in regex matches but I did not see the same issue  
in " Like " comparisons.

Regex is a bytewise comparison.

Like.. I am not sure.

--
Tom

On 20 Feb 2009, at 06:16, Markus Hoenicka wrote:

> Quoting Torsten Bronger <[email protected]>:
>
>> No, but I'm sure this would solve the problem then.  It sounds
>> highly plausible.
>>
>> Okay, so the only issue that remains is that you can't (sanely)
>> search for patterns like M.ller.  You need it e.g. if you don't know
>> whether Müller was inserted into the DB as Muller or Müller.
>> Admittetly, this use case is rare but it may be confusing sometimes.
>>
>
> Another issue is that the data stored in your MySQL database are not
> valid UTF-8 data. You just don't notice (except when you search for
> umlauts) because MySQL converts them back to correct UTF-8 whenever
> you retrieve data via RefDB. This is going to cause trouble if you
> ever upgrade libdbi-drivers.
>
>> Given that RefDB isn't a resource hog so speed is not an issue, I
>> still think though that PG should be prefered over MySQL in case you
>> have the choice.
>>
>
> If you do that, upgrading libdbi-drivers is certainly not required.
> And this is why RefDB uses libdbi after all: to leave the choice to
> the users.
>
> regards,
> Markus
>
> -- 
> Markus Hoenicka
> [email protected]
> (Spam-protected email: replace the quadrupeds with "mhoenicka")
> http://www.mhoenicka.de
>
>
>
> ---------------------------------------------------------------------- 
> --------
> Open Source Business Conference (OSBC), March 24-25, 2009, San  
> Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the  
> Enterprise
> -Strategies to boost innovation and cut costs with open source  
> participation
> -Receive a $600 discount off the registration fee with the source  
> code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> Refdb-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/refdb-users


------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H