Issue 44151 - sql error with fields name containing accents
Summary: sql error with fields name containing accents
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: christoph.lukasiak
QA Contact: issues@dba
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2005-03-05 13:35 UTC by merlin622
Modified: 2006-05-31 14:29 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description merlin622 2005-03-05 13:35:16 UTC 
In OOo 2.0 Beta (1.9.79, french), I encounter an error while testing an SQL code
on an MS ACCESS file : Syntax error in SQL expression
parse error, expecting 'BETWEEN' or 'IN' or 'SQL_TOKEN_LIKE'

This error appears with a valid SQL code, when this code refer to a field with
an accentuated letter (ie like : AnnéeImpression). 

If I rename that field (ie in : AnneeImpression) it works fine.
Comment 1 flibby05 2005-04-21 18:16:27 UTC 
internal QA comment:
have a look at issue 21719, too; looks like double
Comment 2 christoph.lukasiak 2005-04-25 11:39:58 UTC 
change owner
Comment 3 christoph.lukasiak 2005-04-26 10:42:00 UTC 
clu->maxweber: unfortunately the issue you mentioned was never really solved (it
looked like a single case) - now we have to rethink this topic

clu->all: has anybody an idea, what can influence this behavior?
Comment 4 christoph.lukasiak 2005-06-29 09:20:29 UTC 
clu: does this still occure in a current version? please acknowledge:
http://download.openoffice.org/680/index.html

thx
Comment 5 merlin622 2005-06-29 17:21:21 UTC 
Good job ! It works fine in the latest build.

Thank you
Comment 6 marc.neumann 2005-06-30 08:11:00 UTC 
Hi,

Thanks, so we can close this issue now as FIXED.

Bye Marc
Comment 7 marc.neumann 2005-06-30 08:11:25 UTC 
Hi,

I close this issue now.

Bye Marc