HI,

I am using mssql4 adapter.

For table:

CREATE TABLE myTable (
Column_a varchar (10) COLLATE French_CI_AS NOT NULL,
Column_b varchar (10) COLLATE Latin1_General_CI_AS NOT NULL,
Column_c varchar (10) COLLATE Estonian_CS_AS NOT NULL)

I create a view:

CREATE VIEW v_myTable
AS
SELECT
CONVERT (nvarvhar (10), Column_a) AS Column_a,
CONVERT (nvarvhar (10), Column_b) AS Column_b,
CONVERT (nvarvhar (10), Column_c) AS Column_c
FROM myTable

I connect the adapter to the view
Now everything works well

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to