[openstack-dev] UTF-8 required charset/encoding for openstack database?

Roman Podoliaka rpodolyaka at mirantis.com
Mon Mar 10 21:04:19 UTC 2014


Hi all,

>>> It sounds like for the near future my best bet would be to just set the install scripts to configure postgres (which is used only for openstack) to default to utf-8.  Is that a fair summation?

Yes. UTF-8 is a reasonable default value.

Thanks,
Roman

On Mon, Mar 10, 2014 at 1:36 PM, Chris Friesen
<chris.friesen at windriver.com> wrote:
> On 03/10/2014 02:02 PM, Ben Nemec wrote:
>
>> We just had a discussion about this in #openstack-oslo too.  See the
>> discussion starting at 2014-03-10T16:32:26
>>
>> http://eavesdrop.openstack.org/irclogs/%23openstack-oslo/%23openstack-oslo.2014-03-10.log
>
>
> In that discussion dhellmann said, "I wonder if we make any assumptions
> elsewhere that we are using utf8 in the database"
>
> For what it's worth I came across
> "https://wiki.openstack.org/wiki/Encoding", which proposed a rule:
>
> "All external text that is not explicitly encoded (database storage,
> commandline arguments, etc.) should be presumed to be encoded as utf-8."
>
>
>> While it seems Heat does require utf8 (or at least matching character
>> sets) across all tables, I'm not sure the current solution is good.  It
>> seems like we may want a migration to help with this for anyone who
>> might already have mismatched tables.  There's a lot of overlap between
>> that discussion and how to handle Postgres with this, I think.
>
>
> I'm lucky enough to be able to fix this now, I don't have any real
> deployments yet.
>
> It sounds like for the near future my best bet would be to just set the
> install scripts to configure postgres (which is used only for openstack) to
> default to utf-8.  Is that a fair summation?
>
> Chris
>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev



More information about the OpenStack-dev mailing list