Thanks, good idea indeed. I added that to my todo list.
On Jul 11, 3:38 pm, Nate <[EMAIL PROTECTED]> wrote:
> You don't need to change the source. Just extend the driver and
> override the correct method.
>
> On Jul 10, 8:45 pm, bitkidoku <[EMAIL PROTECTED]> wrote:
>
> > Thank you very much :-) I did a change in the source in a similar way.
> > It is dirty but it works.
>
> > On Jul 11, 12:32 am, James K <[EMAIL PROTECTED]> wrote:
>
> > > Oh, PS - I modified the hack so that it only runs when it recognizes
> > > an XML type from SQL 2005. If you change my
> > > $fieldDescription[$fields[$i]]['type'] == 'xml' to
> > > $fieldDescription[$fields[$i]]['type'] == 'text', it should work for
> > > ntext fields in general.
>
> > > - James
>
> > > On Jul 10, 12:34 pm, James K <[EMAIL PROTECTED]> wrote:
>
> > > > The official word from the CakePHP team is that "CakePHP does not
> > > > support ntext fields". You're stuck using the text casting hack. I'm
> > > > using MS SQL myself, and have had to use it, unfortunately.
>
> > > > I'm using 1.2 RC2 and have successfully gotten that same hack to work
> > > > - you have to change it a bit to work with the changes introduced in
> > > > RC1. Here's my version of the fields function from RC2:
>
> > > > function fields(&$model, $alias = null, $fields = array(),
> > > > $quote =
> > > > true) {
> > > > if (empty($alias)) {
> > > > $alias = $model->alias;
> > > > }
> > > > $fields = parent::fields($model, $alias, $fields,
> > > > false);
> > > > $count = count($fields);
>
> > > > $fieldDescription = $this->describe($model);
>
> > > > if ($count >= 1 && $fields[0] != '*' &&
> > > > strpos($fields[0],
> > > > 'COUNT(*)') === false) {
> > > > for ($i = 0; $i < $count; $i++) {
> > > > $prepend = '';
>
> > > > if (strpos($fields[$i], 'DISTINCT') !==
> > > > false) {
> > > > $prepend = 'DISTINCT ';
> > > > $fields[$i] =
> > > > trim(str_replace('DISTINCT', '', $fields[$i]));
> > > > }
> > > > $fieldAlias =
> > > > count($this->__fieldMappings);
>
> > > > if (!preg_match('/\s+AS\s+/i',
> > > > $fields[$i])) {
> > > > if (strpos($fields[$i], '.')
> > > > === false) {
> > > >
> > > > $this->__fieldMappings[$alias . '__' . $fieldAlias] = $alias .
> > > > '.' . $fields[$i];
> > > > if
> > > > ($fieldDescription[$fields[$i]]['type'] == 'xml') {
> > > > $fieldName =
> > > > "CAST(CAST(".$this->name($alias . '.' .
> > > > $fields[$i])." AS VARCHAR(8000)) AS TEXT)";
> > > > } else {
> > > > $fieldName =
> > > > $this->name($alias . '.' . $fields[$i]);
> > > > }
> > > > $fieldAlias =
> > > > $this->name($alias . '__' . $fieldAlias);
> > > > } else {
> > > > $build = explode('.',
> > > > $fields[$i]);
> > > >
> > > > $this->__fieldMappings[$build[0] . '__' . $fieldAlias] =
> > > > $fields[$i];
> > > > $fieldName =
> > > > $this->name($build[0] . '.' . $build[1]);
> > > > $fieldAlias =
> > > > $this->name(preg_replace("/^\[(.+)\]$/", "$1",
> > > > $build[0]) . '__' . $fieldAlias);
> > > > }
> > > > if
> > > > ($model->getColumnType($fields[$i]) == 'datetime') {
> > > > $fieldName =
> > > > "CONVERT(VARCHAR(20), {$fieldName}, 20)";
> > > > }
> > > > $fields[$i] = "{$fieldName} AS
> > > > {$fieldAlias}";
> > > > }
> > > > $fields[$i] = $prepend . $fields[$i];
> > > > }
> > > > }
> > > > return $fields;
> > > > }
>
> > > > On Jul 10, 9:59 am, bitkidoku <[EMAIL PROTECTED]> wrote:
>
> > > > > Hi everyone,
>
> > > > > I have a problem using my existing MSSQL DB. I get the following
> > > > > error:
> > > > > "SQL Error: Unicode data in a Unicode-only collation or ntext data
> > > > > cannot be sent to clients using DB-Library (such as ISQL) or ODBC
> > > > > version 3.7 or earlier. [CORE\cake\libs\model\datasources
> > > > > \dbo_source.php, line 512]"
>
> > > > > I encountered this error before while writing my own PHP code. It can
> > > > > be 'solved' casting ntext field to text. The closest solution for
> > > > > CakePHP I found is this:https://trac.cakephp.org/ticket/4287
>
> > > > > But since that applies to 1.2.0.6311 I couldn't make it work at the
> > > > > moment.
>
> > > > > Does anyone have any idea resolving this issue?
> > > > > Thanks in advance :)
>
> > > > > PS: Why do I insist on using MSSQL? Well, that is another story... I
> > > > > am not very happy about that but I have to.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
