[YSQL] Support of encoding, collation and ctype in CREATE DATABASE

[deem0n]

Jira Link: DB-1918
In PostgreSQL you can run

CREATE DATABASE mi with encoding 'UTF8'  lc_collate='ru_RU.UTF-8' lc_ctype='ru_RU.UTF-8' template=template0;

Seems nothing is yet supported in Yugabyte :-(

ERROR:  Value other than default for encoding option is not yet supported
ERROR:  Value other than default for lc_collate option is not yet supported
ERROR:  Value other than default for lc_ctype option is not yet supported

tested on PostgreSQL 11.2-YB-2.0.0.0-b0

[saulfrank]

Just experienced this problem instead of using postgresql for an application.

[meatherly]

Same. I was trying to use it with active record. Any suggestions?

[ndeodhar]

Thanks for reporting @saulfrank and @meatherly . Which collate and encoding options were you trying with?

[meatherly]

I'm no database guru by no means but this is the error I'm currently getting:

Caused by:
PG::FeatureNotSupported: ERROR:  Value other than default for encoding option is not yet supported
LINE 1: CREATE DATABASE "people" ENCODING = 'unicode'
                                     ^
HINT:  Please report the issue on https://github.com/YugaByte/yugabyte-db/issues
/usr/local/bundle/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `exec'

[meatherly]

btw I also cross referenced your ruby on rails example to see that you have the same line: encoding: unicode in there.

I'm using the kubernetes getting started not sure if that has something todo with it either.

Let me know if there is anymore info you need and I'll do my best to help out as much as I can.

[ndeodhar]

Thanks for the details - that's helpful! It'll be easy for us to add support for UNICODE. Will keep you posted on the progress.

[ndeodhar]

@meatherly Created a smaller issue to track support for UNICODE encoding: #3595

[meatherly]

Wow! you guys are awesome!!