[FB-Tracker] Created: (CORE-5575) isql crash on accented character insert

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[FB-Tracker] Created: (CORE-5575) isql crash on accented character insert

JIRA tracker@firebirdsql.org
isql crash on accented character insert

                 Key: CORE-5575
                 URL: http://tracker.firebirdsql.org/browse/CORE-5575
             Project: Firebird Core
          Issue Type: Bug
          Components: ISQL
    Affects Versions: 3.0.2
         Environment: Windows Vista sp2
            Reporter: Sergio Reyes-Peniche
            Priority: Minor

My Windows cmd.exe defaults to DOS850. I can insert accented characters into an utf8 database from isql like this:

insert into test01 (m_text) values (_dos850 'Séptimo registro.');

select * from test01 shows gibberish instead of the 'é'. If I exit from isql, change codepage to UTF8 with
`chcp 65001` and run isql again, the 'é' shows OK (I have my cmd.exe configured to use Lucida Console, a unicode font).

But, with cmd.exe using UTF8, if I try now:

insert into test01 (m_text) values ('Enésimo registro.');

isql crashes and returns me to the cmd prompt.

I have tried with (_utf8 'Enésimo registro.') and (_dos850 'Enésimo registro.') and isql keeps crashing. I must exit isql,
chcp 850, run isql and insert the new data, exit isql, chcp 65001 and rerun isql to check the new inserts.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel