Posts

Showing posts from July, 2012

Why not work with the CSV file and encoding together

Image
The answer is simple - Microsoft excel not support it. Came to do simple experiments (next exercise does not need to know Development). Open notepad-  Copy the following text (it is in Hebrew because of the example of the encoding) עמודה 1, עמודה 2, עמודה 3 טקסט 1, טקסט 2, טקסט 3 טקסט 11, טקסט 22, טקסט 33 Now save it with encoding - Unicode. The result you receive a Hebrew - but only one column. Now save it with encoding of UTF-8 Now the columns fine but where the Hebrew? If you try to open the same file in other programs such as One-Note it will work well. My recommendation to work less with CSV (with ms. excel). Yours, Roi

Apps for SharePoint 2013

Image
A few days ago out version of the SharePoint  2013   (15) Beta. An emerging idea of SharePoint 2013 is the Apps . What is Apps for SharePoint? And how is it different from the Solutions? To the best of my understanding, App is Package (. App) also contains a WSP course, but also AppManifest.xml and Other files. While solution (WSP) can build by self-developed or from Third-party. The app can be obtained from Internal App Catalog (contains apps approved and uploaded by the organization) or from Public SharePoint Store. Apps can be used in your hosted or on-premises SharePoint App code is installed on a separate web site from your other sites in its own, isolated, domain or in the cloud (cloud-based apps). While Solutions can be used in your hosted (sandbox solutions only) or on-premises SharePoint Solution code is installed as a full trust solution (in the global assembly cache) or as a sandboxed solution. For more information. You  can be viewed at … ...

Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.

Image
How to insert/update image column om SQL? When you try to do this on sql server 2008 you got an error update [tbl_items] set [ImagePlayer]= 'C:\Projects\Images\item.jpg' where [ID]=1 The error message was: Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query. Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query All you need is to do BulkColumn Code for update update [tbl_items] set [ImagePlayer]=BulkColumn FROM OPENROWSET ( Bulk 'C:\Projects\Images\item.jpg' , SINGLE_BLOB) AS BLOB where [ID]=1 (1 row(s) affected) Code for Insert INSERT INTO [ScoutMe].[dbo].[tbl_Players]   ([ID],   [ImagePlayer])    SELECT 1,      BulkColumn FROM OPENROWSET (        Bulk 'C:\Projects\Images\item.jpg' , SINGLE_BLOB) AS BLOB...

Saving changes is not permitted - Sql server

Image
I got an error message when I try to change my table on sql server 2008 R2 Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created. Saving changes is not permitted   All you need to is go to: Options -> Designers -> Table and Database Designers ... and turn off the " Prevent saving changes that requirde table re-creation " Prevent saving changes that requirde table re-creation and click OK Twice User Chenges Thanks, Roi