Can't insert '𡚸' to nvarchar2

[zhangguojvn]

Describe the bug

When inserting Chinese '𡚸' into a field of type nvarchar2, the result is '?'

To Reproduce

`
id := time.Now().Unix()

db.Exec("INSERT INTO "TESTUCHAR" ("ID","U_CHAR","VAR_CHAR") VALUES (:1,:2,:3)", id, "𡚸", "𡚸")

row := db.QueryRow("SELECT "U_CHAR" FROM "TESTUCHAR" WHERE ID = :1", id)

var result string

row.Scan(&result)

fmt.Print(result)

// output is : ?
`

Expected behavior

Insert normal characters

Error output

no error

Your oracle client version

21.7.0.0.0dbru

Your godror version

v0.34.0

Your go version

1.19.1

Your gcc version

gcc version 8.5.0 20210514 (Red Hat 8.5.0-4) (GCC)

Machine (please complete the following information):

• OS: [centos in docker]
• Architecture: [x86_64]
• Version: [centos 8]

[sudarshan12s]

Is it possible to confirm if you see same issue with 19c DB version.
I verified with cloud db (contrib/free.db , 19.21.0.1.0 ) and 21.3.0.0.0 , it works fine.

Also can you share the DB charset used (SELECT value AS db_charset FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET')

my setup has this.
AL32UTF8

[zhangguojvn]

My database character set is ZHS16GBK.

I will

godror/stmt.go

Line 1160 in 91603ea

info.typ, info.natTyp = C.DPI_ORACLE_TYPE_VARCHAR, C.DPI_NATIVE_TYPE_BYTES

From

`

Info.typ, info.natTyp=C.DPI_ ORACLE_ TYPE_ VARCHAR, C.DPI_ NATIVE_ TYPE_ BYTES

`

Change to

`

Info.typ, info.natTyp=C.DPI_ ORACLE_ TYPE_ NVARCHAR, C.DPI_ NATIVE_ TYPE_ BYTES

`

And then it worked.

Perhaps I can create a new type such as "godror.Nchar" is dedicated to insert Nvarchar type data

[tgulacsi]

A separate godror.Nstring type sounds good.GT