<html><body>
<p>Hi Bogdan,<br>
<br>
Thanks for your rapid response. Answers to your questions:<br>
<br>
1. The script opensipsdbctl.mysql, line 106, excludes both "utf8" and "ucs2". Thus with standard scripts the database cannot have a default utf8 charset.<br>
<br>
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.<br>
<br>
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.<br>
<br>
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.<br>
<br>
Thanks,<br>
Kennard<br>
<br>
<br>
<i>(See attached file: opensips-mysqlcharset.patch)</i><br>
<br>
<img width="16" height="16" src="cid:2__=07BBFD3FDFF3DE348f9e8a93df9@logitech.com" border="0" alt="Inactive hide details for Bogdan-Andrei Iancu ---09/27/2010 11:44:39 PM---Hi Kennard, Kennard_White@logitech.com wrote:"><font color="#424282">Bogdan-Andrei Iancu ---09/27/2010 11:44:39 PM---Hi Kennard, Kennard_White@logitech.com wrote:</font><br>
<br>
<font size="2" color="#5F5F5F">From: </font><font size="2">Bogdan-Andrei Iancu <bogdan@voice-system.ro></font><br>
<font size="2" color="#5F5F5F">To: </font><font size="2">OpenSIPS users mailling list <users@lists.opensips.org></font><br>
<font size="2" color="#5F5F5F">Date: </font><font size="2">09/27/2010 11:44 PM</font><br>
<font size="2" color="#5F5F5F">Subject: </font><font size="2">Re: [OpenSIPS-Users] utf8 mysql DB charset</font><br>
<font size="2" color="#5F5F5F">Sent by: </font><font size="2">users-bounces@lists.opensips.org</font><br>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<tt>Hi Kennard,<br>
<br>
Kennard_White@logitech.com wrote:<br>
><br>
> Hi,<br>
><br>
> The script opensipsdbctl.mysql seems to go to some length to prevent <br>
> UTF8 charsets for the DB.<br>
><br>
can you give you such example ?<br>
><br>
> Can anyone tell me why this is? E.g., what breaks with UTF8 tables?<br>
><br>
what tables you need to support UTF8 ?<br>
><br>
><br>
> My current thinking is to make the charset a modparam of the db_mysql <br>
> module, use mysql_options to set that charset, and then set the <br>
> charset of the DB schema to be UTF8.<br>
><br>
that will be a mysql-specific extension, right ?<br>
<br>
Regards,<br>
Bogdan<br>
><br>
><br>
> Will this work?<br>
><br>
> Thanks,<br>
> Kennard<br>
><br>
> ------------------------------------------------------------------------<br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> Users@lists.opensips.org<br>
> </tt><tt><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></tt><tt><br>
> <br>
<br>
<br>
-- <br>
Bogdan-Andrei Iancu<br>
OpenSIPS Bootcamp<br>
15 - 19 November 2010, Edison, New Jersey, USA<br>
</tt><tt>www.voice-system.ro</tt><tt><br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
Users@lists.opensips.org<br>
</tt><tt><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></tt><tt><br>
</tt><br>
</body></html>