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

["Henry Lafleur" <lafleurh@gmail.com>]

[-- 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;