bug#1502: CR/LF Unicode Problem: UTF-8 file with problem

bug#1502: CR/LF Unicode Problem: UTF-8 file with problem

[Henry Lafleur]

[-- Attachment #1.1: Type: text/plain, Size: 576 bytes --]

Here's the file that is causing the problem.

It starts with the with the 3-byte order mark and each line ends with with
CR/LF except the two lines with character codes > 128 which end only in LF.
When I open the file in Windows Emacs, each LF is preceeded by an additional
CR so the lines with CR/LF end in CR/CR/LF and lines that end in LF end in
CR/LF.

If I start emacs with the -Q option, I get the same result. Normally I start
Emacs by running the runemacs.exe. I'm running on Windows. (I'll check the
problem on Linux once I get the file there also.)

Thanks,

Henry.

[-- Attachment #1.2: Type: text/html, Size: 734 bytes --]

[-- Attachment #2: RRTestAppend1.sql --]
[-- Type: text/plain, Size: 1084 bytes --]

CREATE TABLE IF NOT EXISTS bum_script_tb (
    script_id int NOT NULL,
    applied_date datetime NOT NULL,
    CONSTRAINT pk_bum_script PRIMARY KEY (script_id, applied_date)
);

CREATE TABLE IF NOT EXISTS bum_change_tb (
    change_id int NOT NULL,
    script_id int,
    applied_date datetime NOT NULL,
    CONSTRAINT pk_bum_change PRIMARY KEY (change_id, applied_date)
);

CREATE TRIGGER def_bum_script_date BEFORE INSERT ON bum_script_tb
FOR EACH ROW
    SET NEW.applied_date = NOW();

CREATE TRIGGER def_bum_change_date BEFORE INSERT ON bum_change_tb
FOR EACH ROW
    SET NEW.applied_date = NOW();

-- $$North America/South America

/**/

SELECT 'North America/South America' AS Message;

INSERT INTO continent (ENGLISH, RU) VALUES ('NORTH AMERICA','AMÉRICA DEL NORTE');
INSERT INTO continent (ENGLISH, RU) VALUES ('SOUTH AMERICA','AMÉRICA DEL SUR');


SELECT 'DONE';

INSERT INTO bum_change_tb (change_id, script_id) VALUES (1693, 1354);

INSERT INTO bum_script_tb (script_id) VALUES (1354);

UPDATE version_tb SET version_number = 1354;

bug#1502: CR/LF Unicode Problem: UTF-8 file with problem

[Henry Lafleur]

[-- Attachment #1.1: Type: text/plain, Size: 884 bytes --]

OK, Emacs 22.1 on Linux (OpenSUSE 10.3) works just fine. The problem appears
to be isloated to Windows. I'm running Windows XP service pack 2, Emacs 22.1
or 22.3 and have the problem.

Thanks,

Henry.

On Sun, Dec 7, 2008 at 11:25 PM, Henry Lafleur <lafleurh@gmail.com> wrote:

>
> Here's the file that is causing the problem.
>
> It starts with the with the 3-byte order mark and each line ends with with
> CR/LF except the two lines with character codes > 128 which end only in LF.
> When I open the file in Windows Emacs, each LF is preceeded by an additional
> CR so the lines with CR/LF end in CR/CR/LF and lines that end in LF end in
> CR/LF.
>
> If I start emacs with the -Q option, I get the same result. Normally I
> start Emacs by running the runemacs.exe. I'm running on Windows. (I'll check
> the problem on Linux once I get the file there also.)
>
> Thanks,
>
> Henry.
>

[-- Attachment #1.2: Type: text/html, Size: 1316 bytes --]

[-- Attachment #2: RRTestAppend1.sql --]
[-- Type: text/plain, Size: 1084 bytes --]

CREATE TABLE IF NOT EXISTS bum_script_tb (
    script_id int NOT NULL,
    applied_date datetime NOT NULL,
    CONSTRAINT pk_bum_script PRIMARY KEY (script_id, applied_date)
);

CREATE TABLE IF NOT EXISTS bum_change_tb (
    change_id int NOT NULL,
    script_id int,
    applied_date datetime NOT NULL,
    CONSTRAINT pk_bum_change PRIMARY KEY (change_id, applied_date)
);

CREATE TRIGGER def_bum_script_date BEFORE INSERT ON bum_script_tb
FOR EACH ROW
    SET NEW.applied_date = NOW();

CREATE TRIGGER def_bum_change_date BEFORE INSERT ON bum_change_tb
FOR EACH ROW
    SET NEW.applied_date = NOW();

-- $$North America/South America

/**/

SELECT 'North America/South America' AS Message;

INSERT INTO continent (ENGLISH, RU) VALUES ('NORTH AMERICA','AMÉRICA DEL NORTE');
INSERT INTO continent (ENGLISH, RU) VALUES ('SOUTH AMERICA','AMÉRICA DEL SUR');


SELECT 'DONE';

INSERT INTO bum_change_tb (change_id, script_id) VALUES (1693, 1354);

INSERT INTO bum_script_tb (script_id) VALUES (1354);

UPDATE version_tb SET version_number = 1354;

bug#1502: CR/LF Unicode Problem: UTF-8 file with problem

[jasonr]

found 1502 22.3
fixed 1502 23.0.50
thanks

Quoting Henry Lafleur <lafleurh@gmail.com>:

> It starts with the with the 3-byte order mark and each line ends with with
> CR/LF except the two lines with character codes > 128 which end only in LF.
> When I open the file in Windows Emacs, each LF is preceeded by an additional
> CR so the lines with CR/LF end in CR/CR/LF and lines that end in LF end in
> CR/LF.

This seems to be fixed in the CVS trunk, though I can reproduce it in 22.3.

Processed: Re: bug#1502: CR/LF Unicode Problem: UTF-8 file with problem

[Emacs bug Tracking System]

Processing commands for control@emacsbugs.donarmstrong.com:

> found 1502 22.3
bug#1502: CR/LF Unicode Problem
bug marked as found in version 22.3.

> fixed 1502 23.0.50
bug#1502: CR/LF Unicode Problem
bug marked as fixed in version 23.0.50.

> thanks
Stopping processing here.

Please contact me if you need assistance.

Don Armstrong
(administrator, Emacs bugs database)