[OpenSIPS-Users] utf8 mysql DB charset

[Kennard_White at logitech.com]

Hi Bogdan,

Thanks for your rapid response. Answers to your questions:

1. The script opensipsdbctl.mysql, line 106,  excludes both "utf8" and
"ucs2". Thus with standard scripts the database cannot have a default utf8
charset.

2.We need the user table used by www_authenticate() to support passwords
with UTF8. Beyond that, any display name needs to be handled as UTF8. That
said, none of the modules we use currently store display names in DB, so
not an issue.

3. Beyond the tables themselves, the connection mode needs to be UTF8 so
that when we invoke stored procedures in the DB, then UTF8 values (such as
display names and passwords) are passed cleanly. When connection is in
latin1 mode, they get passed as escaped latin1.

4. Yes, mysql specific extension, and it is attached. This appears to work
(it solves the UTF8 password problem), but I'm worried about hidden
side-effects.

Thanks,
Kennard


(See attached file: opensips-mysqlcharset.patch)



From:	Bogdan-Andrei Iancu <bogdan at voice-system.ro>
To:	OpenSIPS users mailling list <users at lists.opensips.org>
Date:	09/27/2010 11:44 PM
Subject:	Re: [OpenSIPS-Users] utf8 mysql DB charset
Sent by:	users-bounces at lists.opensips.org



Hi Kennard,

Kennard_White at logitech.com wrote:
>
> Hi,
>
> The script opensipsdbctl.mysql seems to go to some length to prevent
> UTF8 charsets for the DB.
>
can you give you such example ?
>
> Can anyone tell me why this is? E.g., what breaks with UTF8 tables?
>
what tables you need to support UTF8 ?
>
>
> My current thinking is to make the charset a modparam of the db_mysql
> module, use mysql_options to set that charset, and then set the
> charset of the DB schema to be UTF8.
>
that will be a mysql-specific extension, right ?

Regards,
Bogdan
>
>
> Will this work?
>
> Thanks,
> Kennard
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>


--
Bogdan-Andrei Iancu
OpenSIPS Bootcamp
15 - 19 November 2010, Edison, New Jersey, USA
www.voice-system.ro


_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100928/cbed510e/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: graycol.gif
Type: image/gif
Size: 105 bytes
Desc: not available
Url : http://lists.opensips.org/pipermail/users/attachments/20100928/cbed510e/attachment.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: opensips-mysqlcharset.patch
Type: application/octet-stream
Size: 1862 bytes
Desc: not available
Url : http://lists.opensips.org/pipermail/users/attachments/20100928/cbed510e/attachment.obj