Eldar Amantay steppefox

Somehow the datatype is "char", which apparently is limited to 255 characters. BUT the DB is storing more than 255 characters.

Converting the field to TEXT works perfectly for some reason.

SELECT CONVERT(TEXT,fld_name) FROM TABLE_NAME

answered Jun 2 '10 at 21:30

Derek Adair

http://code.jquery.com/jquery-1.10.2.min.js

https://github.com/Firehed/php-daemon - превращает PHP в демона
https://sculpin.io/ - static site generator
http://blog.phpdeveloper.org/?p=706 - security php.ini scanner

**** Validators ****

array('name','match','pattern' => '/^[a-zA-Z\s]+$/','message' => 'Только английские буквы'),
array('name','filter', 'filter'=>'strtolower'),
array('image','file','allowEmpty'=>true,'maxFiles'=>10,'types'=>'png,jpg,jpeg'),
array('text','filter','filter'=>array($obj=new CHtmlPurifier(),'purify')),

**** Own validator ****

public function passwordStrength($attribute,$params)

	/upload/*
	/assets/*
	/protected/runtime/*
	/themes/classic/views/
	/protected/framework/
	/public/image-content/*
	*.tar.gz
	*.sql
	*config.local.php
	!dump.tar.gz

	function findCatalogCategory($arr=array(),$id=0,$s=''){
	$ms=CatalogCategory::model()->findAll(array('condition'=>'`parent_id`='.$id,'order'=>'title','select'=>array('id','title')));
	foreach ($ms as $m){
	$arr[]=array('title'=>$s.$m->title,'id'=>$m->id);
	if(CatalogCategory::model()->count(array('condition'=> '`parent_id`='.$m->id,'order'=>'title','select'=>array('id','title')))>0){
	$arr=findCatalogCategory($arr,$m->id,($s.$m->title.' - '));
	}
	}
	return $arr;
	}

	public function relations()
	{
	return array(
	'roles'=>array(self::HAS_MANY,'Role','group_id'),
	'users'=>array(self::HAS_MANY,'User',array('user_id'=>'id'),'through'=>'roles'),
	'comments'=>array(self::HAS_MANY,'Comment',array('id'=>'user_id'),'through'=>'users'),
	);
	}

	//set cookie
	Yii::app()->request->cookies['cookie_name'] = new CHttpCookie('cookie_name', $value);

	//get cookie
	$cookie = Yii::app()->request->cookies['cookie_name']->value;
	$cookie = (string)Yii::app()->request->cookies['cookie_name'];

	//delete cookie
	unset(Yii::app()->request->cookies['cookie_name']);

	return [].map.call(document.querySelectorAll('a.tooltip-open'), function(link) {
	return link.getAttribute('href');
	});

	$hash = CPasswordHelper::hashPassword($password);
	CPasswordHelper::verifyPassword($password, $hash);