Topic profile page for Varchar.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Varchar.
Topic "Varchar" was discussed 12,858 times on 402 sites in last 3 months
Started 16 hours, 27 minutes ago (2009-11-28 18:12:00)
by Steve Pickster
> I need to clean a db from SQL injected scripts. The bak file is from a 2000 db and ntext, text, and image data types have been changed to nvarchar(max), varchar(max), and varbinary(max), I have a SQL script which changes all the text types but the image/varbinary returns Implicit conversion from data type varchar(max) to varbinary(max) is not allowed. Use the ...
Started 2 days, 2 hours ago (2009-11-27 07:54:00)
by bhanu2217
> I am using SQL server 2005 database. I have a varchar field which stores date in the format "DD-MM-YYYY" now what i want to do is, convert this date from database(varchar format) to c# date time format but if i use DateTime.parse it considers the DD as MM and MM as DD. This is basically a expiry date and i want to compare this with today date and see if the ...
Started 5 days, 4 hours ago (2009-11-24 05:53:00)
by AlexKravchenko
Hello everyone! I have a question. When creating a column in a table (each field of this column will contain a small string), I have two options to define this column's type: PHP Code: email TEXT and PHP Code: email VARCHAR ( 255 ) Let's say each field of this column will contain an email address. Which is a better option to write...
Started 5 days, 18 hours ago (2009-11-23 15:43:00)
by cool_ranjeet
i've taken a column as LONG VARCHAR; RDbView iView; TBuf iSmsBody; but iSmsBody.Copy(iViewLabel.ColDes(2));-------------- >is the crash point? if i take VARCHAR instead of LONG VARCHAR it works fine.
Started 5 days, 19 hours ago (2009-11-23 15:20:00)
by romario
ok I know this is a very noob question but then again I am a bit of a noob. I have been googling TEXT versus VARCHAR to try and find out which one to use various columns, unfortunately I haven't had great luck finding definitive information. Is there a link anyone can point me to? I was always under that impression that VARCHAR saves space but takes up more processing time...
Started 6 days, 1 hour ago (2009-11-23 09:18:00)
by coolguy
Hi, We have a field of datatype varchar(max,null) in the SQL Server 2008 database. When we build the same field as an object of character type/Long Text in the BO Designer, it doesn't parse. Here is the error: The expression type is not compatible with the object. When I pull the field in the webi report discarding the above error , it displays only first character of each value....
Started 6 days, 11 hours ago (2009-11-22 23:21:00)
by Aaron Clauson
I use an SQL varchar field to store my datetimes and would like Linq-to-SQL to store DateTime fields using ToString("o"). [Column(Name = "inserted", DbType = "varchar(30)", CanBeNull = false)] public DateTime Inserted { get; set; } A Linq-to-SQL insert will result in a format of "mm/dd/yyyy HH:mm:ss". How can I specify that the datetime string format used when storing in ...
Started 1 week, 1 day ago (2009-11-20 15:57:00)
by djj55
Hello, I am looking at encryption in SQL Server 2008. I have the basics down but have a question about sizing the encrypted column. I have two columns of data I want to encrypt. One 9 characters and one 20 characters. Currently VARCHAR(9) and VARCHAR(20). (Yes I know that the VAR means space savings.) What is the minimum VARBINARY needed for these, or a better question how do I calculate ...
Started 1 week, 2 days ago (2009-11-20 10:27:00)
by djj55
Hello, I am looking at encryption in 2008. I have the basics down but have a question about sizing the encrypted column. Yes I know that the VAR means space savings. I have two columns of data I want to encrypt. One 9 characters and one 20 characters. Currently VARCHAR(9) and VARCHAR(20). What is the minimum VARBINARY needed for these, or a better question how do I calculate the VARBINARY ...
Started 3 days, 10 hours ago (2009-11-25 23:54:00)
by helloworld7
I know mysql but I'm new to postgre. I found grouping is a bit different. If you have a field in select then you need to identify on the group as well. Here's the problem, I want to select the latest data and here's the table data. items table transid, memberid, item, date, status 123, 1234, apple, 2009-11-23, PROCESSING 124, 1234, orange, 2009-11-23, PROCESSING 124, 1234, ...
Started 3 days, 12 hours ago (2009-11-25 22:36:00)
by helloworld7
I know mysql but I'm new to postgre. I found grouping is a bit different. If you have a field in select then you need to identify on the group as well. Here's the problem, I want to select the latest data and here's the table data. items table transid, memberid, item, date, status 123, 1234, apple, 2009-11-23, PROCESSING 124, 1234, orange, 2009-11-23, PROCESSING 124, ...
Started 5 days, 22 hours ago (2009-11-23 12:25:00)
by MPhillips1982
I am having a strange problem. I am running a select command and trying to fill a datatable. Here are the two tests I ran: SqlConnection connection = new SqlConnection(connstring); connection.Open(); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "SELECT * FROM TableOne"; DataTable table = new DataTable(); SqlDataAdapter adapter = ...
Started 1 week, 1 day ago (2009-11-21 04:58:00)
by william wil
Hi there, I've got something that is - IMHO- very strange, and I'm just posting it to see if somebody understands this one... I've got 2 tables: CREATE TABLE IF NOT EXISTS `1_index` ( `id` int(11) unsigned NOT NULL, `word` varchar(255) NOT NULL, `language` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_...
Started 1 week, 1 day ago (2009-11-20 16:33:00)
by crouse Junior Member
Be Kind, I'm new, and I have searched the forums... MS Sql Server Uniqueidentifiers (GUID) and Pentaho don't seem to want to work together very well. I'm able to retrieve a field defined as GUID by casting it as varchar in the sql, not a big issue. But since most all the tables are PK'd by the GUID, I'll have to do a lot of database lookups on the GUID. My problem is: how do...
Started 3 days, 9 hours ago (2009-11-26 01:07:00)
by pragal
Dear, Im using BO 5.1.7, Database as SQL Server2000. How to convert the date, In sql server im using below query and populate the data. cast(cast(Install_date as varchar(12)) as datetime) =cast(cast(getdate()-1 as varchar(12)) as datetime) Please let me know how to do the above query in Desinger.
Started 1 week ago (2009-11-21 10:43:00)
by co.ador
If you notice in the picture there is no a submit bottom but let's suppose there is one. table one... MySQL Code: [ code ] CREATE TABLE IF NOT EXISTS `restaurants` ( `restaurants_id` MEDIUMINT ( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT , `restaurantname` VARCHAR ( 255 ) NOT NULL , `image` VARCHAR ( 100 ) DEFAULT NULL , PRIMARY KEY...
Started 1 week ago (2009-11-22 10:20:00)
by ujjwal
In My sql, My table structure is as follows: Code: CREATE TABLE `tbl_lecture` ( `lecture_id` bigint(20) NOT NULL auto_increment, `s_id` bigint(20) NOT NULL, `lecture_date` date NOT NULL, `lecture_Heading` varchar(500) NOT NULL, `lecture_Preparatory` varchar(500) default NULL, `lecture_Preparatory_file` varchar(500) default NULL, `lecture_Notes` varchar(500) ...
Started 1 week, 1 day ago (2009-11-21 04:07:00)
by mirzahat
Hello, my form data is inserted this way: Server Error in '/MirzaShop' Application. Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query. SqlCommand command = new SqlCommand("INSERT INTO gameTable(gameName, gamePlatform) VALUES (@gameName, @gamePlatform)", connection); SqlParameter nameField = new SqlParameter...
Started 1 week ago (2009-11-21 12:22:00)
by svibuk
in my asp.net application i have the following query str=" insert into temptable select * from maintable" execute str="alter temptable add [tid] varchar(50)" execute i want to insert values to this columns how do i do it i have the value in a variable the varaible values r a string multipele values eg variabkle=(3,78,55,890) ............... how do i insert this values...
![Pentaho Data Integration [Kettle]](http://icons.boardreader.com/5e/81/5e81c0b836cd5680ca424a12bd2453d2.png "Pentaho Data Integration [Kettle]"){kind=icon}
