❔ Inserting Unicode characters into an Oracle database-issue
help please on net core 6 with dapper -When inserting Unicode characters into an Oracle database using Dapper dynamic parameters in a .NET Core 6 API, when the inserted value appears as "¿" instead of the expected Unicode character like "😀"
you can see the the code for insert data in the photo attached
4 Replies
Fair warning I know 0 about oracle dbs
What is the type of the column you are inserting into? What text encoding is it expecting? When you say the insert value appears as "?" what do you mean, does it appear that way in some db viewer tool or when you read it back from the DB? Does it look okay if you reinterpret the string as the original encoding (i.e. is the db damaging it somehow)?
Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.the issue not resolved..
the type of the column in the database is nvarchar so it need to support unicode char, and it saved like this with ? instead "😀" in the db
when i try to insert with the regular ado for oracle db it works like charm, but when using dapper its saving ? insted of unicode char
Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.