Try this. Open your table that has the two memo (text data type) columns in design mode. select the first column and in the properties down below, select the Collation property and click the elipse button for that property. The Collation dialog will open. By default, SQL Collation is selected. Select Windows Collation and pick your language. Do that same for the other column but pick a different language. See if that gives you what you are looking for.
|