I think this change (and maybe before it too) is wrong. If one creates a "User1", you should not create USER1. Nor "úser2" should be ÚSER2.
User names should respect quoted identifier rules, when quoted. So only unquoted ASCII characters should be uppercased. There may be an exception, in DPB tags. AFAIK, roles were uppercased if DPB does not have quotes. I think this is weird, but maybe it should be equal for user names. I also didn't understood why did you inserted a new unicode upper-case table, since that were already available and usable. But I didn't fully reviewed the patch. Adriano On 30/04/2015 10:53, Alexander Peshkov (JIRA) wrote: > [ > http://tracker.firebirdsql.org/browse/CORE-4760?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel > ] > > Alexander Peshkov resolved CORE-4760. > ------------------------------------- > > Fix Version/s: 3.0 Beta 2 > Resolution: Fixed > > Support for non-ascii logins is checked only when using SQL interface to > manage users. Use of deprecated gsec and/or services API may be not possible. > Appropriate locale should be correctly setup on both client and server. > > Non-ascii logins now do not differ in any way from ascii logins, including no > case sensitivity (i.e. logins Zotov or ZOTOV are the same logins even when > typed in russian). > >> Can not create user with non-ascii (multi-byte) characters in it's name >> ----------------------------------------------------------------------- >> >> Key: CORE-4760 >> URL: http://tracker.firebirdsql.org/browse/CORE-4760 >> Project: Firebird Core >> Issue Type: Bug >> Components: Charsets/Collation >> Reporter: Pavel Zotov >> Assignee: Alexander Peshkov >> Fix For: 3.0 Beta 2 >> >> >> It seems that there is no explicit prohibition of creating user with name >> that containing non-ascii characters. >> But currently it is not possible: >> 1) On Linux console, charset = UTF8: >> $ /opt/fb30ss/bin/isql localhost/3333:/var/db/fb30/e30.fdb -z -ch utf8 >> ISQL Version: LI-T3.0.0.31797 Firebird 3.0 Beta 2 >> Server version: >> LI-T3.0.0.31797 Firebird 3.0 Beta 2 >> LI-T3.0.0.31797 Firebird 3.0 Beta 2/tcp (oel64)/P13 >> LI-T3.0.0.31797 Firebird 3.0 Beta 2/tcp (oel64)/P13 >> Database: localhost/3333:/var/db/fb30/e30.fdb >> SQL> create user "Кузьмин" password '123'; -- name of user typed in CYRILLIC >> letters >> Statement failed, SQLSTATE = HY000 >> gsec error >> SQL> exit; >> 2) GSEC also fails: >> $ /opt/fb30ss/bin/gsec -user sysdba -pass masterke -add "Кузьмин" -pw 123 >> Bad international character in tag isc_spb_sec_username >> Cannot transliterate character between character sets >> Invalid or incomplete multibyte or wide character ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
