Re: [google-cloud-sql-discuss] Re: Create Locales or change Template1 locale

Hi Nick,

well, of course I pretend to use UTF8, but when sorting results (collation), it's not the same sorting in English than in Spanish.

For example, this set: Óscar, Peter, Angel, in english get sorted like this: Angel, Peter, Óscar. But in Spanish, the order would be: Angel, Óscar, Peter.

There are many languages which letters allow tildes, special accents, etc, that would need special locales?

Is it too complex to implement?

Thank you very much.

2017-03-27 23:22 GMT+02:00 'paynen' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com>:

Hey Oscar,

Thanks for this report. I've replicated your findings. I'm unsure at the moment what solution to offer. Could you explain more about your use-case, and why you can't just store UTF-8 data without setting any locale?

Cheers,

Nick
Cloud Platform Community Support

On Monday, March 20, 2017 at 11:54:45 AM UTC-4, Oscar Serrano wrote:

Hi,

I'm trying to create a new postgresql database, but I cannot use the spanish Location. I've tried this:

create database mydb with ENCODING = 'UTF-8' LC_CTYPE = 'es_ES' LC_COLLATE = 'es_ES';

But I get an error: invalid Locale Name es_ES

How do I create it?

I've tried this:

postgres=> create collation es (locale="es_ES.utf8");ERROR: could not create locale "es_ES.utf8": Success
As you can say, it says Success, but also I get the error.How should I proceed?
Thank you.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/mISMIL3PNFY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/396f11c6-1349-4510-83c8-a82f9dae81cf%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CANX%3DucTm-QQMs-bmEohvwDtTgrM%2B%3D%2B4iX%3DW6dpqBPvPZPuCv%2Bg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.