Delphi Remobjects and Unicode with Unidac

I have an issue with unicode and utf8 and the unidac driver. (I am using ro 9.4.1353) When I compile and run on my development computer everything works fine but when I deploy to a server the program starts having unicode (utf8) issues with the following error:

No mapping for the Unicode character exists in the target multi-byte code page

Are there dll’s that I need to check?

what DB (MSSQL, MySQL, etc) you are using?

It is Oracle with the daconnections looking like

  <ConnectionString>UniDAC?AuxDriver=Oracle;Server=some;Database=some;UserID=userid;Password=some;Net=0;UseUnicode=True;</ConnectionString>
  <ConnectionType>Oracle</ConnectionType>

Thanks everyone. I figured out the issue.

the connection string needs to have “SpecificOptions.UseUnicode=True;” not “UseUnicode=True” for the driver to work properly.

1 Like