Inserting to SQL Server NTEXT Field

1.8k Views Asked by At

I want to insert a row into a SQL Server table via Laravel Query Builder.

I'm converting unicode characters with the method below:

mb_convert_encoding($value, 'UCS-2LE', mb_detect_encoding($value, mb_detect_order(), true))

Everything works fine except for ntext fields. I cannot insert a row if there exists an ntext field. I can insert as NULL. But I cannot insert anyting in the ntext field.

But inserting for other types is working fine. And I'm getting a SQL Server 206 error when the data for the ntext field is not null.

What is the problem ?

0

There are 0 best solutions below