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

Unfortunately current release of CloudSQL for PostgreSQL does not include extra locales.

This is something we aware of. We should be able to include more locales in one of the next releases.

--
Vladimir Rusinov
PostgreSQL SRE, Google Ireland

Google Ireland Ltd.,Gordon House, Barrow Street, Dublin 4, Ireland
Registered in Dublin, Ireland
Registration Number: 368047

On Tue, Mar 28, 2017 at 1:13 PM, Oscar Serrano <oscar.serrano.sacristan@gmail.com> wrote:

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.

--
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/CAE1wr-yRcqFagYiGBc75jEBsVAuNmbE2Zim78PBpF21Pd-VkwA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.