Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Diacritic replaced when EF update records [DNET553] #527

Closed
firebird-automations opened this issue Apr 29, 2014 · 5 comments
Closed

Diacritic replaced when EF update records [DNET553] #527

firebird-automations opened this issue Apr 29, 2014 · 5 comments

Comments

@firebird-automations
Copy link

Submitted by: Alexx (ralexx)

Attachments:
Firebird.zip

Votes: 1

I'm using EF code first and mapped varchar field that contains some diacritics.
Retrieve one record with diacritic, concatenate space (only to enforce updating) and submit changes.

All diacritics updated or inserted with EF are replaced by a dot.

Inserting an equivalent record (with diacritics) by FbCommand and exactly the same connectionstring do not cause this problem.

@firebird-automations
Copy link
Author

Commented by: @cincuranet

How's your code looks like?

@firebird-automations
Copy link
Author

Commented by: Alexx (ralexx)

I've attached a lite .Net project to give an example,

It seems the problem occurs only when a record is updated not on insert.

The first refresh in UI update the first record and insert another one (Name = "éléphant" for both).

The second refresh show the result of the update ("éléphant" -> ".l.phant" for updated, "éléphant" don't change for inserted).

update :

In the console output i saw that EF uses the type "Text" for this column instead of "VarChar".
I reproduce the same behaviour using FbCommand with a parameter of type "Text" too.
I don't know why but I if I specify "VarChar" in the mapping the update statement continue to use "Text" and do this bug :(

@firebird-automations
Copy link
Author

Modified by: Alexx (ralexx)

Attachment: Firebird.zip [ 12504 ]

@firebird-automations
Copy link
Author

Commented by: @cincuranet

You should use UTF-8 charset for your connection.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Closed [ 6 ]

resolution: Won't Fix [ 2 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants