how to capture Chinese characters

[uoghk]

I create a list form with 4 combo to filter the records.

If click a "Test" on Status combo, it shows on "Test" status records.
However, if select a value in the PriceType combo, it shows nothing.
The PriceType's combo name is Filter2cbo.
When debug to step into the code, it shows the Me.Filter2cbo is "??".

    If Me.Filter2cbo <> "" Then
        FormFilter = "[PriceType] = '" & Me.Filter2cbo & "'"
    End If

How to convert "??" to its real value?
Thanks.

[CJ_London]

you have a mixture of fonts and suspect you need to change your language settings. - see this link https://social.msdn.microsoft.com/Fo...board-language

[Micron]

Or maybe the combo rowsource is from a query that groups by on a memo field. Have seen this before, but in queries, not forms.

[uoghk]

Thanks Ajax.
I try the methods in your URL.
It does not work.

Thanks Micron.
I don't find a memo field type in Access table.
I try set the combo rowsource to query a "Long Text" table field, but it does not work.
Can you explain more?

[uoghk]

After try the methods in Ajax URL, I can see the Chinese characters in debug mode.
The FormFilter is set to [PriceType]="上路", but it cannot shows 上路 records.
I try enter SELECT * FROM customer WHERE [PriceType]="上路" in the Query Designer.
It also return no record. Strange!
Is it the problem that I am using Link Table to SQL Server?
The PriceType is nvarchar(10) data type.

[Micron]

Thanks Ajax.
I try the methods in your URL.
It does not work.

Thanks Micron.
I don't find a memo field type in Access table.
I try set the combo rowsource to query a "Long Text" table field, but it does not work.
Can you explain more?

Sorry, I forgot that memo field type was changed to "long text" some time back. Essentially, they are one and the same thing. So if you're grouping on a long text field it's the same thing.

[ArviLaanemets]

You can identify/recreate any character of any language using it's unicode value. So create an udf, which reads an unicode value of character, and another one, which returns the character from it's unicode value, and the use those udf's in your query. Also, in case there is a limited set of those chinese characters/expressions, you can have a translation table with columns for character/expression and matching filter conditions - maybe then you'll do without udf's.

[uoghk]

thanks ArviLaanemets
not quite understand to create udf about unicode value.
can you give me sample?

[Gicu]

You might want to read about collations in SQL server:

https://docs.microsoft.com/en-us/sql...l-server-ver15
https://www.red-gate.com/simple-talk...tions-shy-ask/


Cheers,

[uoghk]

I finally set the table's collation to Chinese_Hong_Kong_Stroke_90_CI_AS, then I can query with Chinese characters.

[Gicu]

Great news, thanks for letting us know!
Cheers,